package com.tanhua.dubbo.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.tanhua.domain.db.SoulReport;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface SoulReportMapper extends BaseMapper<SoulReport> {

    @Select("select * from tb_soul_report where questionnaire_id=#{questionnaireId} and #{score} between score_min and score_max ")
    public SoulReport queryReport(@Param("questionnaireId") String questionnaireId, @Param("score") String score);
}
